{\rtf1\ansi\ansicpg936\cocoartf2580
\cocoatextscaling0\cocoaplatform0{\fonttbl\f0\fnil\fcharset134 PingFangSC-Regular;\f1\fnil\fcharset0 HelveticaNeue;}
{\colortbl;\red255\green255\blue255;\red100\green100\blue100;\red38\green38\blue38;\red132\green12\blue21;
\red19\green85\blue52;\red135\green136\blue100;\red98\green0\blue117;\red37\green0\blue153;\red152\green0\blue15;
\red0\green0\blue0;}
{\*\expandedcolortbl;;\cssrgb\c46667\c46667\c46667;\cssrgb\c20000\c20000\c20000;\cssrgb\c59608\c10196\c10196;
\cssrgb\c6667\c40000\c26667;\cssrgb\c60000\c60000\c46667;\cssrgb\c46667\c0\c53333;\cssrgb\c20000\c0\c66667;\cssrgb\c66667\c6667\c6667;
\cssrgb\c0\c0\c0;}
\paperw11900\paperh16840\margl1440\margr1440\vieww11520\viewh8400\viewkind0
\deftab720
\pard\pardeftab720\partightenfactor0

\f0\fs32 \cf2 \expnd0\expndtw0\kerning0
\outl0\strokewidth0 \strokec2 \'d7\'f7\'d2\'b5
\f1 1
\f0 \'a3\'ba
\f1 \
\pard\pardeftab720\sa256\partightenfactor0

\f0 \cf3 \strokec3 \'cc\'e2\'c4\'bf\'d2\'aa\'c7\'f3\'a3\'ba
\f1 \

\f0 \'b8\'f9\'be\'dd\'d2\'aa\'c7\'f3\'b1\'e0\'d0\'b4\'cf\'e0\'b9\'d8\'b5\'c4
\f1 sql
\f0 \'d3\'ef\'be\'e4\'a3\'ac\'d2\'d4\'cf\'c2\'ca\'c7\'cc\'e1\'b9\'a9\'ba\'c3\'b5\'c4\'ca\'fd\'be\'dd\'a3\'ac\'c7\'eb\'cf\'c8\'d6\'b4\'d0\'d0\'cc\'e1\'b9\'a9\'b5\'c4\'ca\'fd\'be\'dd
\f1 \
\pard\pardeftab720\partightenfactor0

\f0\fs28\fsmilli14400 \cf3 \'ca\'fd\'be\'dd\'b1\'ed\'bd\'e9\'c9\'dc
\f1 \
\
\pard\pardeftab720\partightenfactor0
\cf4 \strokec4 --\cf5 \strokec5 1.
\f0 \cf3 \strokec3 \'d1\'a7\'c9\'fa\'b1\'ed
\f1 \
Student\cf6 \strokec6 (\cf3 \strokec3 SId,Sname,Sage,Ssex\cf6 \strokec6 )\cf3 \strokec3 \
\cf4 \strokec4 --\cf3 \strokec3 SId 
\f0 \'d1\'a7\'c9\'fa\'b1\'e0\'ba\'c5
\f1 ,Sname 
\f0 \'d1\'a7\'c9\'fa\'d0\'d5\'c3\'fb
\f1 ,Sage 
\f0 \'b3\'f6\'c9\'fa\'c4\'ea\'d4\'c2
\f1 ,Ssex 
\f0 \'d1\'a7\'c9\'fa\'d0\'d4\'b1\'f0
\f1 \
\
\cf4 \strokec4 --\cf5 \strokec5 2.
\f0 \cf3 \strokec3 \'bf\'ce\'b3\'cc\'b1\'ed
\f1 \
Course\cf6 \strokec6 (\cf3 \strokec3 CId,Cname,TId\cf6 \strokec6 )\cf3 \strokec3 \
\cf4 \strokec4 --\cf3 \strokec3 CId 
\f0 \'bf\'ce\'b3\'cc\'b1\'e0\'ba\'c5
\f1 ,Cname 
\f0 \'bf\'ce\'b3\'cc\'c3\'fb\'b3\'c6
\f1 ,TId 
\f0 \'bd\'cc\'ca\'a6\'b1\'e0\'ba\'c5
\f1 \
\
\cf4 \strokec4 --\cf5 \strokec5 3.
\f0 \cf3 \strokec3 \'bd\'cc\'ca\'a6\'b1\'ed
\f1 \
Teacher\cf6 \strokec6 (\cf3 \strokec3 TId,Tname\cf6 \strokec6 )\cf3 \strokec3 \
\cf4 \strokec4 --\cf3 \strokec3 TId 
\f0 \'bd\'cc\'ca\'a6\'b1\'e0\'ba\'c5
\f1 ,Tname 
\f0 \'bd\'cc\'ca\'a6\'d0\'d5\'c3\'fb
\f1 \
\
\cf4 \strokec4 --\cf5 \strokec5 4.
\f0 \cf3 \strokec3 \'b3\'c9\'bc\'a8\'b1\'ed
\f1 \
SC\cf6 \strokec6 (\cf3 \strokec3 SId,CId,score\cf6 \strokec6 )\cf3 \strokec3 \
\cf4 \strokec4 --\cf3 \strokec3 SId 
\f0 \'d1\'a7\'c9\'fa\'b1\'e0\'ba\'c5
\f1 ,CId 
\f0 \'bf\'ce\'b3\'cc\'b1\'e0\'ba\'c5
\f1 ,score 
\f0 \'b7\'d6\'ca\'fd
\f1 \
\
\cf4 \strokec4 --
\f0 \cf3 \strokec3 \'d1\'a7\'c9\'fa\'b1\'ed
\f1  Student\
\pard\pardeftab720\partightenfactor0
\cf7 \strokec7 create\cf3 \strokec3 \'a0\cf7 \strokec7 table\cf3 \strokec3 \'a0Student\cf6 \strokec6 (\cf3 \strokec3 SId\'a0\cf8 \strokec8 varchar\cf6 \strokec6 (\cf5 \strokec5 10\cf6 \strokec6 )\cf3 \strokec3 ,Sname\'a0\cf8 \strokec8 varchar\cf6 \strokec6 (\cf5 \strokec5 10\cf6 \strokec6 )\cf3 \strokec3 ,Sage\'a0\cf8 \strokec8 datetime\cf3 \strokec3 ,Ssex\'a0\cf8 \strokec8 varchar\cf6 \strokec6 (\cf5 \strokec5 10\cf6 \strokec6 ))\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0Student\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '01'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'d5\'d4\'c0\'d7
\f1 '\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '1990-01-01'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'c4\'d0
\f1 '\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0Student\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '02'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'c7\'ae\'b5\'e7
\f1 '\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '1990-12-21'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'c4\'d0
\f1 '\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0Student\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '03'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'cb\'ef\'b7\'e7
\f1 '\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '1990-12-20'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'c4\'d0
\f1 '\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0Student\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '04'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'c0\'ee\'d4\'c6
\f1 '\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '1990-12-06'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'c4\'d0
\f1 '\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0Student\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '05'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'d6\'dc\'c3\'b7
\f1 '\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '1991-12-01'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'c5\'ae
\f1 '\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0Student\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '06'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'ce\'e2\'c0\'bc
\f1 '\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '1992-01-01'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'c5\'ae
\f1 '\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0Student\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '07'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'d6\'a3\'d6\'f1
\f1 '\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '1989-01-01'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'c5\'ae
\f1 '\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0Student\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '09'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'d5\'c5\'c8\'fd
\f1 '\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '2017-12-20'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'c5\'ae
\f1 '\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0Student\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '10'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'c0\'ee\'cb\'c4
\f1 '\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '2017-12-25'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'c5\'ae
\f1 '\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0Student\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '11'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'c0\'ee\'cb\'c4
\f1 '\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '2012-06-06'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'c5\'ae
\f1 '\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0Student\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '12'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'d5\'d4\'c1\'f9
\f1 '\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '2013-06-13'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'c5\'ae
\f1 '\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0Student\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '13'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'cb\'ef\'c6\'df
\f1 '\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '2014-06-01'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'c5\'ae
\f1 '\cf6 \strokec6 )\cf3 \strokec3 ;\
\
\pard\pardeftab720\partightenfactor0
\cf4 \strokec4 --
\f0 \cf3 \strokec3 \'bf\'c6\'c4\'bf\'b1\'ed
\f1  Course\
\pard\pardeftab720\partightenfactor0
\cf7 \strokec7 create\cf3 \strokec3 \'a0\cf7 \strokec7 table\cf3 \strokec3 \'a0Course\cf6 \strokec6 (\cf3 \strokec3 CId\'a0\cf8 \strokec8 varchar\cf6 \strokec6 (\cf5 \strokec5 10\cf6 \strokec6 )\cf3 \strokec3 ,Cname nvarchar\cf6 \strokec6 (\cf5 \strokec5 10\cf6 \strokec6 )\cf3 \strokec3 ,TId\'a0\cf8 \strokec8 varchar\cf6 \strokec6 (\cf5 \strokec5 10\cf6 \strokec6 ))\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0Course\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '01'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'d3\'ef\'ce\'c4
\f1 '\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '02'\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0Course\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '02'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'ca\'fd\'d1\'a7
\f1 '\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '01'\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0Course\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '03'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'d3\'a2\'d3\'ef
\f1 '\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '03'\cf6 \strokec6 )\cf3 \strokec3 ;\
\
\pard\pardeftab720\partightenfactor0
\cf4 \strokec4 --
\f0 \cf3 \strokec3 \'bd\'cc\'ca\'a6\'b1\'ed
\f1  Teacher\
\pard\pardeftab720\partightenfactor0
\cf7 \strokec7 create\cf3 \strokec3 \'a0\cf7 \strokec7 table\cf3 \strokec3 \'a0Teacher\cf6 \strokec6 (\cf3 \strokec3 TId\'a0\cf8 \strokec8 varchar\cf6 \strokec6 (\cf5 \strokec5 10\cf6 \strokec6 )\cf3 \strokec3 ,Tname\'a0\cf8 \strokec8 varchar\cf6 \strokec6 (\cf5 \strokec5 10\cf6 \strokec6 ))\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0Teacher\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '01'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'d5\'c5\'c8\'fd
\f1 '\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0Teacher\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '02'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'c0\'ee\'cb\'c4
\f1 '\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0Teacher\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '03'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '
\f0 \'cd\'f5\'ce\'e5
\f1 '\cf6 \strokec6 )\cf3 \strokec3 ;\
\
\pard\pardeftab720\partightenfactor0
\cf4 \strokec4 --
\f0 \cf3 \strokec3 \'b3\'c9\'bc\'a8\'b1\'ed
\f1  SC\
\pard\pardeftab720\partightenfactor0
\cf7 \strokec7 create\cf3 \strokec3 \'a0\cf7 \strokec7 table\cf3 \strokec3 \'a0SC\cf6 \strokec6 (\cf3 \strokec3 SId\'a0\cf8 \strokec8 varchar\cf6 \strokec6 (\cf5 \strokec5 10\cf6 \strokec6 )\cf3 \strokec3 ,CId\'a0\cf8 \strokec8 varchar\cf6 \strokec6 (\cf5 \strokec5 10\cf6 \strokec6 )\cf3 \strokec3 ,score\'a0\cf8 \strokec8 decimal\cf6 \strokec6 (\cf5 \strokec5 18\cf3 \strokec3 ,\cf5 \strokec5 1\cf6 \strokec6 ))\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0SC\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '01'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '01'\cf3 \strokec3 \'a0,\'a0\cf5 \strokec5 80\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0SC\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '01'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '02'\cf3 \strokec3 \'a0,\'a0\cf5 \strokec5 90\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0SC\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '01'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '03'\cf3 \strokec3 \'a0,\'a0\cf5 \strokec5 99\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0SC\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '02'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '01'\cf3 \strokec3 \'a0,\'a0\cf5 \strokec5 70\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0SC\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '02'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '02'\cf3 \strokec3 \'a0,\'a0\cf5 \strokec5 60\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0SC\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '02'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '03'\cf3 \strokec3 \'a0,\'a0\cf5 \strokec5 80\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0SC\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '03'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '01'\cf3 \strokec3 \'a0,\'a0\cf5 \strokec5 80\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0SC\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '03'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '02'\cf3 \strokec3 \'a0,\'a0\cf5 \strokec5 80\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0SC\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '03'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '03'\cf3 \strokec3 \'a0,\'a0\cf5 \strokec5 80\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0SC\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '04'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '01'\cf3 \strokec3 \'a0,\'a0\cf5 \strokec5 50\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0SC\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '04'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '02'\cf3 \strokec3 \'a0,\'a0\cf5 \strokec5 30\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0SC\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '04'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '03'\cf3 \strokec3 \'a0,\'a0\cf5 \strokec5 20\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0SC\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '05'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '01'\cf3 \strokec3 \'a0,\'a0\cf5 \strokec5 76\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0SC\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '05'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '02'\cf3 \strokec3 \'a0,\'a0\cf5 \strokec5 87\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0SC\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '06'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '01'\cf3 \strokec3 \'a0,\'a0\cf5 \strokec5 31\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0SC\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '06'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '03'\cf3 \strokec3 \'a0,\'a0\cf5 \strokec5 34\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0SC\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '07'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '02'\cf3 \strokec3 \'a0,\'a0\cf5 \strokec5 89\cf6 \strokec6 )\cf3 \strokec3 ;\
\cf7 \strokec7 insert\cf3 \strokec3 \'a0\cf7 \strokec7 into\cf3 \strokec3 \'a0SC\'a0\cf7 \strokec7 values\cf6 \strokec6 (\cf9 \strokec9 '07'\cf3 \strokec3 \'a0,\'a0\cf9 \strokec9 '03'\cf3 \strokec3 \'a0,\'a0\cf5 \strokec5 98\cf6 \strokec6 )\cf3 \strokec3 ;\
\pard\pardeftab720\sa256\partightenfactor0

\fs32 \cf3 \uc0\u8232 \
\uc0\u8232 \
1.
\f0 \'b2\'e9\'d1\'af\'d4\'da
\f1  SC 
\f0 \'b1\'ed\'b4\'e6\'d4\'da\'b3\'c9\'bc\'a8\'b5\'c4\'d1\'a7\'c9\'fa\'d0\'c5\'cf\'a2
\f1 \
\pard\pardeftab720\partightenfactor0

\fs28\fsmilli14400 \cf3 \
\pard\pardeftab720\sa256\partightenfactor0

\fs32 \cf3 \uc0\u8232 \
2.
\f0 \'b2\'e9\'d1\'af\'a1\'b8\'c0\'ee\'a1\'b9\'d0\'d5\'c0\'cf\'ca\'a6\'b5\'c4\'ca\'fd\'c1\'bf
\f1 \
\pard\pardeftab720\partightenfactor0

\fs28\fsmilli14400 \cf3 \
\pard\pardeftab720\sa256\partightenfactor0

\fs32 \cf3 \uc0\u8232 \
3.
\f0 \'b2\'e9\'d1\'af\'d1\'a7\'b9\'fd\'a1\'b8\'d5\'c5\'c8\'fd\'a1\'b9\'c0\'cf\'ca\'a6\'ca\'da\'bf\'ce\'b5\'c4\'cd\'ac\'d1\'a7\'b5\'c4\'d0\'c5\'cf\'a2
\f1  \'a0
\f0 \'b6\'e0\'b1\'ed\'c1\'aa\'ba\'cf\'b2\'e9\'d1\'af
\f1 \
\pard\pardeftab720\partightenfactor0

\fs28\fsmilli14400 \cf3 \
\pard\pardeftab720\sa256\partightenfactor0

\fs32 \cf3 \uc0\u8232 \
4.
\f0 \'b2\'e9\'d1\'af\'c4\'d0\'c9\'fa\'a1\'a2\'c5\'ae\'c9\'fa\'c8\'cb\'ca\'fd
\f1  \
\pard\pardeftab720\partightenfactor0

\fs28\fsmilli14400 \cf3 \
\pard\pardeftab720\sa256\partightenfactor0

\fs32 \cf3 \uc0\u8232 \
5.
\f0 \'b2\'e9\'d1\'af
\f1  1990 
\f0 \'c4\'ea\'b3\'f6\'c9\'fa\'b5\'c4\'d1\'a7\'c9\'fa\'c3\'fb\'b5\'a5
\f1  \
\pard\pardeftab720\partightenfactor0

\fs28\fsmilli14400 \cf3 \
\pard\pardeftab720\sa256\partightenfactor0

\fs32 \cf3 \uc0\u8232 \
6.
\f0 \'b2\'e9\'d1\'af\'c3\'bf\'c3\'c5\'bf\'ce\'b3\'cc\'b5\'c4\'c6\'bd\'be\'f9\'b3\'c9\'bc\'a8\'a3\'ac\'bd\'e1\'b9\'fb\'b0\'b4\'c6\'bd\'be\'f9\'b3\'c9\'bc\'a8\'bd\'b5\'d0\'f2\'c5\'c5\'c1\'d0\'a3\'ac\'c6\'bd\'be\'f9\'b3\'c9\'bc\'a8\'cf\'e0\'cd\'ac\'ca\'b1\'a3\'ac\'b0\'b4\'bf\'ce\'b3\'cc\'b1\'e0\'ba\'c5\'c9\'fd\'d0\'f2\'c5\'c5\'c1\'d0
\f1  \
\pard\pardeftab720\partightenfactor0

\fs28\fsmilli14400 \cf3 \
\pard\pardeftab720\sa256\partightenfactor0

\fs32 \cf3 \uc0\u8232 \
7.
\f0 \'b2\'e9\'d1\'af\'bf\'ce\'b3\'cc\'b1\'e0\'ba\'c5\'ce\'aa
\f1  01 
\f0 \'c7\'d2\'bf\'ce\'b3\'cc\'b3\'c9\'bc\'a8\'d4\'da
\f1  80 
\f0 \'b7\'d6\'bc\'b0\'d2\'d4\'c9\'cf\'b5\'c4\'d1\'a7\'c9\'fa\'b5\'c4\'d1\'a7\'ba\'c5\'ba\'cd\'d0\'d5\'c3\'fb
\f1  \
\pard\pardeftab720\partightenfactor0

\fs28\fsmilli14400 \cf3 \
\pard\pardeftab720\sa256\partightenfactor0

\fs32 \cf3 \uc0\u8232 \
8.
\f0 \'b2\'e9\'d1\'af
\f1 " 01 "
\f0 \'bf\'ce\'b3\'cc\'b1\'c8
\f1 " 02 "
\f0 \'bf\'ce\'b3\'cc\'b3\'c9\'bc\'a8\'b8\'df\'b5\'c4\'d1\'a7\'c9\'fa\'b5\'c4\'d0\'c5\'cf\'a2\'bc\'b0\'bf\'ce\'b3\'cc\'b7\'d6\'ca\'fd
\f1  \
\pard\pardeftab720\partightenfactor0

\fs28\fsmilli14400 \cf3 \
\pard\pardeftab720\sa256\partightenfactor0

\fs32 \cf3 \uc0\u8232 \
\pard\pardeftab720\partightenfactor0

\f0 \cf2 \strokec2 \'d7\'f7\'d2\'b5
\f1 2\
\pard\pardeftab720\sa256\partightenfactor0

\f0 \cf3 \strokec3 \'ca\'fd\'be\'dd\'d7\'bc\'b1\'b8\'a3\'ba
\f1 \

\f0 \'d4\'da
\f1 mysql
\f0 \'d6\'d0\'b4\'b4\'bd\'a8\'d2\'bb\'b8\'f6\'ca\'fd\'be\'dd\'b1\'ed
\f1 employee , 
\f0 \'d3\'d0\'d2\'d4\'cf\'c2\'d7\'d6\'b6\'ce
\f1 \
id INT PRIMARY KEY AUTO_INCREMENT,  NAME VARCHAR(10),  gender CHAR(1), -- 
\f0 \'d0\'d4\'b1\'f0
\f1   salary DOUBLE, -- 
\f0 \'b9\'a4\'d7\'ca
\f1   bonus DOUBLE, -- 
\f0 \'bd\'b1\'bd\'f0
\f1   join_date DATE -- 
\f0 \'c8\'eb\'d6\'b0\'c8\'d5\'c6\'da\'ca\'be
\f1 \

\f0 \'c7\'eb\'b8\'f8
\f1  employee 
\f0 \'d4\'b1\'b9\'a4\'b1\'ed\'d6\'d0\'cc\'ed\'bc\'d3\'d2\'bb\'d0\'a9\'ca\'fd\'be\'dd\'a1\'a3
\f1 \
\uc0\u8232 \

\f0 \'d2\'aa\'c7\'f3\'a3\'ba
\f1 \
1.
\f0 \'b1\'e0\'d0\'b4\'d2\'bb\'b8\'f6\'b2\'e2\'ca\'d4\'c0\'e0\'a3\'ac\'d4\'da\'b8\'c3\'b2\'e2\'ca\'d4\'c0\'e0\'d6\'d0\'ca\'b9\'d3\'c3
\f1 PrepareStatement 
\f0 \'b8\'f9\'be\'dd
\f1 name
\f0 \'ba\'cd
\f1 gender
\f0 \'bd\'f8\'d0\'d0\'ca\'fd\'be\'dd\'b2\'e9\'d1\'af\'a3\'ac\'b2\'a2\'bd\'ab\'bd\'e1\'b9\'fb\'b4\'f2\'d3\'a1\'d4\'da\'bf\'d8\'d6\'c6\'cc\'a8\'a1\'a3
\f1 \
2.
\f0 \'d2\'aa\'c7\'f3\'b1\'e0\'d0\'b4\'d2\'bb\'b8\'f6\'b1\'e0\'d0\'b4\'d2\'bb\'b8\'f6
\f1 db.properties , 
\f0 \'ca\'fd\'be\'dd\'bf\'e2\'b5\'c4\'ca\'fd\'be\'dd\'b4\'e6\'b7\'c5\'d4\'da\'c5\'e4\'d6\'c3\'ce\'c4\'bc\'fe\'d6\'d0
\f1 \
3.
\f0 \'d2\'aa\'c7\'f3\'d7\'d4\'bc\'ba\'b1\'e0\'d0\'b4\'d2\'bb\'b8\'f6\'b9\'a4\'be\'df\'c0\'e0
\f1 DBUtils , 
\f0 \'b8\'c3\'c0\'e0\'d6\'d0\'cc\'e1\'b9\'a9\'be\'b2\'cc\'ac\'bb\'f1\'c8\'a1
\f1 Connection
\f0 \'c1\'ac\'bd\'d3\'b5\'c4\'b7\'bd\'b7\'a8
\f1 .\
\uc0\u8232 \

\f0 \'b2\'ce\'bf\'bc\'b4\'f0\'b0\'b8
\f1 :\
db.properties\
\pard\pardeftab720\partightenfactor0

\fs28\fsmilli14400 \cf3 \
\pard\pardeftab720\sa256\partightenfactor0

\fs32 \cf3 \uc0\u8232 \
Emp
\f0 \'ca\'b5\'cc\'e5
\f1 \
\pard\pardeftab720\partightenfactor0

\fs28\fsmilli14400 \cf3 \
\pard\pardeftab720\sa256\partightenfactor0

\fs32 \cf3 \uc0\u8232 \
JDBCUtils
\f0 \'b9\'a4\'be\'df\'c0\'e0
\f1 \
\pard\pardeftab720\partightenfactor0

\fs28\fsmilli14400 \cf3 /**\
\'a0*\'a0\'a0JDBC
\f0 \'b5\'c4\'b9\'a4\'be\'df\'c0\'e0\'a3\'ba
\f1 \
\'a0*\'a0\'a01\'a0
\f0 \'bb\'f1\'c8\'a1\'c1\'ac\'bd\'d3
\f1 \
\'a0*\
\'a0*\'a0\'a02.
\f0 \'ca\'cd\'b7\'c5\'d7\'ca\'d4\'b4
\f1 \
\'a0*/\
\pard\pardeftab720\sa256\partightenfactor0

\fs32 \cf3 \uc0\u8232 \
JDBC_PrepareStatement
\f0 \'b2\'e2\'ca\'d4\'c0\'e0
\f1 \
\pard\pardeftab720\partightenfactor0

\fs28\fsmilli14400 \cf3 \
\pard\pardeftab720\partightenfactor0

\fs32 \cf10 \strokec10 \uc0\u8232 \
}